Relational Data Models
Back to Home
01. Learning Objective
02. Databases
03. Importance of Relational Databases
04. OLAP vs OLTP
05. Quiz 1
06. Structuring the Database: Normalization
07. Objectives of Normal Form
08. Normal Forms
09. Demo 1: Creating Normalized Tables
10. Exercise 1: Creating Normalized Tables
11. Solution: Exercise 1: Creating Normalized Tables
12. Denormalization
13. Demo 2: Creating Denormalized Tables
14. Denormalization Vs. Normalization
15. Exercise 2: Creating Denormalized Tables
16. Solution: Exercise 2: Creating Denormalized Tables
17. Fact and Dimension Tables
18. Star Schemas
19. Benefits of Star Schemas
20. Snowflake Schemas
21. Demo 3: Creating Fact and Dimension Tables
22. Exercise 3: Creating Fact and Dimension Tables
23. Solution: Exercise 3: Creating Fact and Dimension Tables
24. Data Definition and Constraints
25. Upsert
26. Conclusion
Back to Home
13. Demo 2: Creating Denormalized Tables
10 Demo 02-
Here is the link to the demo notebook.
Next Concept